Pandas Profiling Report

Dataset statistics

Number of variables	14
Number of observations	2968
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	347.8 KiB
Average record size in memory	120.0 B

Variable types

Numeric	14

Alerts

`avg_basket_size` is highly overall correlated with `avg_ticket` and 3 other fields	High correlation
`avg_recency_days` is highly overall correlated with `frequency`	High correlation
`avg_ticket` is highly overall correlated with `avg_basket_size` and 3 other fields	High correlation
`delta_buy_return` is highly overall correlated with `avg_basket_size` and 5 other fields	High correlation
`frequency` is highly overall correlated with `avg_recency_days`	High correlation
`gross_revenue` is highly overall correlated with `avg_basket_size` and 5 other fields	High correlation
`items_purchased` is highly overall correlated with `avg_basket_size` and 5 other fields	High correlation
`monetary_returns` is highly overall correlated with `number_returns`	High correlation
`number_returns` is highly overall correlated with `monetary_returns`	High correlation
`purchases` is highly overall correlated with `delta_buy_return` and 4 other fields	High correlation
`recency_days` is highly overall correlated with `purchases`	High correlation
`unique_avg_basket` is highly overall correlated with `unique_products_purchased`	High correlation
`unique_products_purchased` is highly overall correlated with `delta_buy_return` and 4 other fields	High correlation
`frequency` is highly skewed (γ1 = 24.87687084)	Skewed
`monetary_returns` is highly skewed (γ1 = 25.6851608)	Skewed
`customer_id` has unique values	Unique
`recency_days` has 33 (1.1%) zeros	Zeros
`number_returns` has 1481 (49.9%) zeros	Zeros
`monetary_returns` has 1481 (49.9%) zeros	Zeros

Reproduction

Analysis started	2024-01-26 13:27:14.486485
Analysis finished	2024-01-26 13:27:48.616574
Duration	34.13 seconds
Software version	ydata-profiling vv4.6.4
Download configuration	config.json

customer_id
Real number (ℝ)

UNIQUE

Distinct	2968
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15270.377

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	12347
5-th percentile	12619.35
Q1	13798.75
median	15220.5
Q3	16768.5
95-th percentile	17964.65
Maximum	18287
Range	5940
Interquartile range (IQR)	2969.75

Descriptive statistics

Standard deviation	1719.1445
Coefficient of variation (CV)	0.11258036
Kurtosis	-1.2061782
Mean	15270.377
Median Absolute Deviation (MAD)	1489
Skewness	0.032193711
Sum	45322479
Variance	2955457.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
12670	1	< 0.1%
17734	1	< 0.1%
14905	1	< 0.1%
16103	1	< 0.1%
14626	1	< 0.1%
14868	1	< 0.1%
18246	1	< 0.1%
17115	1	< 0.1%
16611	1	< 0.1%
Other values (2958)	2958	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18269	1	< 0.1%

gross_revenue
Real number (ℝ)

HIGH CORRELATION

Distinct	2953
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2693.4851

Minimum	6.2
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	6.2
5-th percentile	229.7325
Q1	570.845
median	1085.51
Q3	2306.905
95-th percentile	7169.562
Maximum	279138.02
Range	279131.82
Interquartile range (IQR)	1736.06

Descriptive statistics

Standard deviation	10135.465
Coefficient of variation (CV)	3.7629558
Kurtosis	397.30132
Mean	2693.4851
Median Absolute Deviation (MAD)	670.84
Skewness	17.635372
Sum	7994263.7
Variance	1.0272766 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1078.96	2	0.1%
2053.02	2	0.1%
331	2	0.1%
1353.74	2	0.1%
889.93	2	0.1%
745.06	2	0.1%
379.65	2	0.1%
2092.32	2	0.1%
731.9	2	0.1%
734.94	2	0.1%
Other values (2943)	2948	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.2	1	< 0.1%
13.3	1	< 0.1%
15	1	< 0.1%
36.56	1	< 0.1%
45	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
140450.72	1	< 0.1%
124564.53	1	< 0.1%
117379.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%
65039.62	1	< 0.1%

recency_days
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	272
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.309299

Minimum	0
Maximum	373
Zeros	33
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	11
median	31
Q3	81
95-th percentile	242
Maximum	373
Range	373
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	77.760922
Coefficient of variation (CV)	1.2091707
Kurtosis	2.7765172
Mean	64.309299
Median Absolute Deviation (MAD)	26
Skewness	1.7980529
Sum	190870
Variance	6046.7611
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.3%
4	87	2.9%
2	85	2.9%
3	85	2.9%
8	76	2.6%
10	67	2.3%
9	66	2.2%
7	66	2.2%
17	64	2.2%
16	55	1.9%
Other values (262)	2218	74.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	33	1.1%
1	99	3.3%
2	85	2.9%
3	85	2.9%
4	87	2.9%
5	43	1.4%
7	66	2.2%
8	76	2.6%
9	66	2.2%
10	67	2.3%

Value	Count	Frequency (%)
373	2	0.1%
372	4	0.1%
371	1	< 0.1%
368	1	< 0.1%
366	4	0.1%
365	2	0.1%
364	1	< 0.1%
360	1	< 0.1%
359	1	< 0.1%
358	4	0.1%

purchases
Real number (ℝ)

HIGH CORRELATION

Distinct	56
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.7243935

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	205
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	8.8577599
Coefficient of variation (CV)	1.5473709
Kurtosis	190.78624
Mean	5.7243935
Median Absolute Deviation (MAD)	2
Skewness	10.765555
Sum	16990
Variance	78.45991
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	784	26.4%
3	499	16.8%
4	393	13.2%
5	237	8.0%
1	190	6.4%
6	173	5.8%
7	138	4.6%
8	98	3.3%
9	69	2.3%
10	55	1.9%
Other values (46)	332	11.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	190	6.4%
2	784	26.4%
3	499	16.8%
4	393	13.2%
5	237	8.0%
6	173	5.8%
7	138	4.6%
8	98	3.3%
9	69	2.3%
10	55	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

unique_products_purchased
Real number (ℝ)

HIGH CORRELATION

Distinct	468
Distinct (%)	15.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	122.76449

Minimum	1
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	9
Q1	29
median	67
Q3	135
95-th percentile	382
Maximum	7838
Range	7837
Interquartile range (IQR)	106

Descriptive statistics

Standard deviation	269.93294
Coefficient of variation (CV)	2.1987868
Kurtosis	354.77884
Mean	122.76449
Median Absolute Deviation (MAD)	44
Skewness	15.706135
Sum	364365
Variance	72863.79
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	43	1.4%
20	37	1.2%
35	35	1.2%
29	35	1.2%
19	34	1.1%
15	33	1.1%
11	32	1.1%
26	31	1.0%
27	30	1.0%
25	30	1.0%
Other values (458)	2628	88.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	6	0.2%
2	14	0.5%
3	15	0.5%
4	17	0.6%
5	26	0.9%
6	29	1.0%
7	18	0.6%
8	19	0.6%
9	26	0.9%
10	28	0.9%

Value	Count	Frequency (%)
7838	1	< 0.1%
5673	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1637	1	< 0.1%

items_purchased
Real number (ℝ)

HIGH CORRELATION

Distinct	1670
Distinct (%)	56.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1582.1044

Minimum	1
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	102.35
Q1	296
median	640
Q3	1399.5
95-th percentile	4403.25
Maximum	196844
Range	196843
Interquartile range (IQR)	1103.5

Descriptive statistics

Standard deviation	5705.2914
Coefficient of variation (CV)	3.6061408
Kurtosis	516.7418
Mean	1582.1044
Median Absolute Deviation (MAD)	421
Skewness	18.737654
Sum	4695686
Variance	32550350
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
150	9	0.3%
88	9	0.3%
246	8	0.3%
272	8	0.3%
84	8	0.3%
260	8	0.3%
288	8	0.3%
1200	7	0.2%
516	7	0.2%
Other values (1660)	2885	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	2	0.1%
12	2	0.1%
16	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
23	1	< 0.1%
25	1	< 0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80263	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%
57885	1	< 0.1%
50255	1	< 0.1%

avg_ticket
Real number (ℝ)

HIGH CORRELATION

Distinct	2956
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	393.16954

Minimum	6.2
Maximum	14844.767
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	6.2
5-th percentile	106.68475
Q1	195.24339
median	305.444
Q3	442.63
95-th percentile	919.0825
Maximum	14844.767
Range	14838.567
Interquartile range (IQR)	247.38661

Descriptive statistics

Standard deviation	489.2179
Coefficient of variation (CV)	1.2442925
Kurtosis	310.35682
Mean	393.16954
Median Absolute Deviation (MAD)	117.18067
Skewness	13.261822
Sum	1166927.2
Variance	239334.16
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
339.72	2	0.1%
512.72	2	0.1%
200.95	2	0.1%
189.825	2	0.1%
186.265	2	0.1%
394.5	2	0.1%
230.74	2	0.1%
145.525	2	0.1%
110.3333333	2	0.1%
162.6075	2	0.1%
Other values (2946)	2948	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.2	1	< 0.1%
9.14	1	< 0.1%
11.67	1	< 0.1%
13.3	1	< 0.1%
15	1	< 0.1%
20.81	1	< 0.1%
26	1	< 0.1%
26.1	1	< 0.1%
28.21666667	1	< 0.1%
28.73142857	1	< 0.1%

Value	Count	Frequency (%)
14844.76667	1	< 0.1%
9341.26	1	< 0.1%
6228.2265	1	< 0.1%
4327.621667	1	< 0.1%
4279.71	1	< 0.1%
4229.365	1	< 0.1%
3914.945	1	< 0.1%
3883.985385	1	< 0.1%
3876.916944	1	< 0.1%
3690.89	1	< 0.1%

avg_recency_days
Real number (ℝ)

HIGH CORRELATION

Distinct	1258
Distinct (%)	42.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	67.302133

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	25.917308
median	48.267857
Q3	85.333333
95-th percentile	200.65
Maximum	366
Range	365
Interquartile range (IQR)	59.416026

Descriptive statistics

Standard deviation	63.505358
Coefficient of variation (CV)	0.94358612
Kurtosis	4.9080488
Mean	67.302133
Median Absolute Deviation (MAD)	26.267857
Skewness	2.066084
Sum	199752.73
Variance	4032.9306
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	25	0.8%
4	22	0.7%
70	21	0.7%
7	20	0.7%
35	19	0.6%
49	18	0.6%
11	17	0.6%
46	17	0.6%
21	17	0.6%
28	16	0.5%
Other values (1248)	2776	93.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	16	0.5%
1.5	1	< 0.1%
2	13	0.4%
2.5	1	< 0.1%
2.601398601	1	< 0.1%
3	15	0.5%
3.321428571	1	< 0.1%
3.330357143	1	< 0.1%
3.5	2	0.1%
4	22	0.7%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
363	1	< 0.1%
362	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1225
Distinct (%)	41.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.11383237

Minimum	0.0054495913
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	0.0054495913
5-th percentile	0.0088935048
Q1	0.016339869
median	0.025898352
Q3	0.049478583
95-th percentile	1
Maximum	17
Range	16.99455
Interquartile range (IQR)	0.033138713

Descriptive statistics

Standard deviation	0.40822056
Coefficient of variation (CV)	3.5861552
Kurtosis	989.06632
Mean	0.11383237
Median Absolute Deviation (MAD)	0.012196886
Skewness	24.876871
Sum	337.85449
Variance	0.16664402
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	198	6.7%
0.0625	18	0.6%
0.02777777778	17	0.6%
0.02380952381	16	0.5%
0.09090909091	15	0.5%
0.08333333333	15	0.5%
0.03448275862	14	0.5%
0.02941176471	14	0.5%
0.03571428571	13	0.4%
0.07692307692	13	0.4%
Other values (1215)	2635	88.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
3	1	< 0.1%
2	6	0.2%
1.142857143	1	< 0.1%
1	198	6.7%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5335120643	1	< 0.1%
0.5	3	0.1%

number_returns
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	23
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1229784

Minimum	0
Maximum	45
Zeros	1481
Zeros (%)	49.9%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	1
95-th percentile	4
Maximum	45
Range	45
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	2.2974109
Coefficient of variation (CV)	2.0458192
Kurtosis	114.43709
Mean	1.1229784
Median Absolute Deviation (MAD)	1
Skewness	8.0232009
Sum	3333
Variance	5.2780967
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
0	1481	49.9%
1	832	28.0%
2	289	9.7%
3	140	4.7%
4	92	3.1%
5	37	1.2%
6	32	1.1%
7	21	0.7%
9	8	0.3%
11	5	0.2%
Other values (13)	31	1.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1481	49.9%
1	832	28.0%
2	289	9.7%
3	140	4.7%
4	92	3.1%
5	37	1.2%
6	32	1.1%
7	21	0.7%
8	5	0.2%
9	8	0.3%

Value	Count	Frequency (%)
45	1	< 0.1%
44	1	< 0.1%
35	1	< 0.1%
27	1	< 0.1%
21	1	< 0.1%
18	2	0.1%
17	1	< 0.1%
15	2	0.1%
14	1	< 0.1%
13	5	0.2%

monetary_returns
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	1076
Distinct (%)	36.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	75.704252

Minimum	0
Maximum	22998.4
Zeros	1481
Zeros (%)	49.9%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.8
Q3	30
95-th percentile	226.875
Maximum	22998.4
Range	22998.4
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	605.35101
Coefficient of variation (CV)	7.9962617
Kurtosis	833.77391
Mean	75.704252
Median Absolute Deviation (MAD)	0.8
Skewness	25.685161
Sum	224690.22
Variance	366449.85
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1481	49.9%
4.95	19	0.6%
9.95	17	0.6%
12.75	17	0.6%
15	16	0.5%
5.9	12	0.4%
25.5	10	0.3%
4.25	10	0.3%
3.75	9	0.3%
19.9	8	0.3%
Other values (1066)	1369	46.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1481	49.9%
0.42	2	0.1%
0.65	1	< 0.1%
0.95	1	< 0.1%
1.25	4	0.1%
1.45	4	0.1%
1.64	1	< 0.1%
1.65	5	0.2%
1.7	2	0.1%
1.79	1	< 0.1%

Value	Count	Frequency (%)
22998.4	1	< 0.1%
14688.24	1	< 0.1%
8511.15	1	< 0.1%
7443.59	1	< 0.1%
5228.4	1	< 0.1%
4815.26	1	< 0.1%
4814.74	1	< 0.1%
4486.24	1	< 0.1%
4429	1	< 0.1%
3677.15	1	< 0.1%

avg_basket_size
Real number (ℝ)

HIGH CORRELATION

Distinct	1978
Distinct (%)	66.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	236.25289

Minimum	1
Maximum	6009.3333
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	44
Q1	103.2375
median	172.29167
Q3	281.54808
95-th percentile	599.58
Maximum	6009.3333
Range	6008.3333
Interquartile range (IQR)	178.31058

Descriptive statistics

Standard deviation	283.8932
Coefficient of variation (CV)	1.2016496
Kurtosis	102.78169
Mean	236.25289
Median Absolute Deviation (MAD)	83.041667
Skewness	7.7018777
Sum	701198.57
Variance	80595.347
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
114	10	0.3%
82	9	0.3%
86	9	0.3%
73	9	0.3%
136	8	0.3%
75	8	0.3%
60	8	0.3%
88	8	0.3%
130	7	0.2%
Other values (1968)	2881	97.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2	0.1%
2	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
6009.333333	1	< 0.1%
4282	1	< 0.1%
3906	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2801	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%
2082.225806	1	< 0.1%

unique_avg_basket
Real number (ℝ)

HIGH CORRELATION

Distinct	1005
Distinct (%)	33.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.161667

Minimum	1
Maximum	299.70588
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	3.4021531
Q1	10
median	17.2
Q3	27.75
95-th percentile	56.9475
Maximum	299.70588
Range	298.70588
Interquartile range (IQR)	17.75

Descriptive statistics

Standard deviation	19.511925
Coefficient of variation (CV)	0.88043576
Kurtosis	27.710745
Mean	22.161667
Median Absolute Deviation (MAD)	8.2
Skewness	3.5001795
Sum	65775.829
Variance	380.7152
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	53	1.8%
14	39	1.3%
11	38	1.3%
20	33	1.1%
9	33	1.1%
1	32	1.1%
17	31	1.0%
18	30	1.0%
10	30	1.0%
5	29	1.0%
Other values (995)	2620	88.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	32	1.1%
1.2	1	< 0.1%
1.25	1	< 0.1%
1.333333333	2	0.1%
1.5	7	0.2%
1.568181818	1	< 0.1%
1.571428571	1	< 0.1%
1.666666667	4	0.1%
1.833333333	1	< 0.1%
2	24	0.8%

Value	Count	Frequency (%)
299.7058824	1	< 0.1%
259	1	< 0.1%
203.5	1	< 0.1%
148	1	< 0.1%
145	1	< 0.1%
136.125	1	< 0.1%
135.5	1	< 0.1%
127	1	< 0.1%
122	1	< 0.1%
118	1	< 0.1%

delta_buy_return
Real number (ℝ)

HIGH CORRELATION

Distinct	2951
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2617.7808

Minimum	-796.86
Maximum	278778.02
Zeros	8
Zeros (%)	0.3%
Negative	3
Negative (%)	0.1%
Memory size	46.4 KiB

Quantile statistics

Minimum	-796.86
5-th percentile	213.114
Q1	552.3125
median	1055.04
Q3	2265.4025
95-th percentile	7018.2475
Maximum	278778.02
Range	279574.88
Interquartile range (IQR)	1713.09

Descriptive statistics

Standard deviation	9929.1953
Coefficient of variation (CV)	3.7929819
Kurtosis	421.91006
Mean	2617.7808
Median Absolute Deviation (MAD)	656.295
Skewness	18.201513
Sum	7769573.4
Variance	98588918
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8	0.3%
598.2	2	0.1%
589.15	2	0.1%
599.9	2	0.1%
306.55	2	0.1%
379.65	2	0.1%
178.96	2	0.1%
331	2	0.1%
1078.96	2	0.1%
2083.42	2	0.1%
Other values (2941)	2942	99.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-796.86	1	< 0.1%
-141.48	1	< 0.1%
-95.93	1	< 0.1%
0	8	0.3%
5.684341886 × 10^-14	1	< 0.1%
4.547473509 × 10^-13	1	< 0.1%
12.24	1	< 0.1%
15	1	< 0.1%
36.56	1	< 0.1%
40.95	1	< 0.1%

Value	Count	Frequency (%)
278778.02	1	< 0.1%
259657.3	1	< 0.1%
189735.53	1	< 0.1%
133007.13	1	< 0.1%
123638.18	1	< 0.1%
114505.32	1	< 0.1%
88138.2	1	< 0.1%
65920.12	1	< 0.1%
62924.1	1	< 0.1%
59419.34	1	< 0.1%

Auto

Heatmap
Table

	avg_basket_size	avg_recency_days	avg_ticket	customer_id	delta_buy_return	frequency	gross_revenue	items_purchased	monetary_returns	number_returns	purchases	recency_days	unique_avg_basket	unique_products_purchased
avg_basket_size	1.000	-0.078	0.824	-0.123	0.570	0.028	0.574	0.729	0.179	0.178	0.101	-0.097	0.449	0.384
avg_recency_days	-0.078	1.000	-0.114	0.019	-0.237	-0.881	-0.249	-0.228	-0.399	-0.422	-0.258	0.109	0.049	-0.165
avg_ticket	0.824	-0.114	1.000	-0.142	0.665	0.057	0.674	0.621	0.257	0.244	0.107	-0.073	0.427	0.376
customer_id	-0.123	0.019	-0.142	1.000	-0.072	-0.002	-0.077	-0.071	-0.056	-0.049	0.026	0.001	-0.007	0.013
delta_buy_return	0.570	-0.237	0.665	-0.072	1.000	0.082	0.994	0.923	0.330	0.363	0.774	-0.419	0.298	0.751
frequency	0.028	-0.881	0.057	-0.002	0.082	1.000	0.091	0.081	0.240	0.236	0.078	0.017	-0.073	0.035
gross_revenue	0.574	-0.249	0.674	-0.077	0.994	0.091	1.000	0.925	0.371	0.391	0.772	-0.414	0.292	0.746
items_purchased	0.729	-0.228	0.621	-0.071	0.923	0.081	0.925	1.000	0.325	0.350	0.718	-0.407	0.322	0.732
monetary_returns	0.179	-0.399	0.257	-0.056	0.330	0.240	0.371	0.325	1.000	0.943	0.296	-0.118	0.018	0.244
number_returns	0.178	-0.422	0.244	-0.049	0.363	0.236	0.391	0.350	0.943	1.000	0.338	-0.143	0.031	0.279
purchases	0.101	-0.258	0.107	0.026	0.774	0.078	0.772	0.718	0.296	0.338	1.000	-0.503	0.025	0.690
recency_days	-0.097	0.109	-0.073	0.001	-0.419	0.017	-0.414	-0.407	-0.118	-0.143	-0.503	1.000	-0.108	-0.436
unique_avg_basket	0.449	0.049	0.427	-0.007	0.298	-0.073	0.292	0.322	0.018	0.031	0.025	-0.108	1.000	0.699
unique_products_purchased	0.384	-0.165	0.376	0.013	0.751	0.035	0.746	0.732	0.244	0.279	0.690	-0.436	0.699	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	customer_id	gross_revenue	recency_days	purchases	unique_products_purchased	items_purchased	avg_ticket	avg_recency_days	frequency	number_returns	monetary_returns	avg_basket_size	unique_avg_basket	delta_buy_return
0	17850	5391.21	372.0	34.0	297.0	1733.0	158.565000	35.500000	17.000000	1.0	102.58	50.970588	8.735294	5288.63
1	13047	3232.59	56.0	9.0	171.0	1390.0	359.176667	27.250000	0.028302	7.0	143.49	154.444444	19.000000	3089.10
2	12583	6705.38	2.0	15.0	232.0	5028.0	447.025333	23.187500	0.040323	2.0	76.04	335.200000	15.466667	6629.34
3	13748	948.25	95.0	5.0	28.0	439.0	189.650000	92.666667	0.017921	0.0	0.00	87.800000	5.600000	948.25
4	15100	876.00	333.0	3.0	3.0	80.0	292.000000	8.600000	0.073171	3.0	240.90	26.666667	1.000000	635.10
5	15291	4623.30	25.0	14.0	102.0	2102.0	330.235714	23.200000	0.040115	5.0	71.79	150.142857	7.285714	4551.51
6	14688	5630.87	7.0	21.0	327.0	3621.0	268.136667	18.300000	0.057221	6.0	523.49	172.428571	15.571429	5107.38
7	17809	5411.91	16.0	12.0	61.0	2057.0	450.992500	35.700000	0.033520	2.0	67.06	171.416667	5.083333	5344.85
8	15311	60767.90	0.0	91.0	2379.0	38194.0	667.779121	4.144444	0.243316	27.0	1348.56	419.714286	26.142857	59419.34
9	16098	2005.63	87.0	7.0	67.0	613.0	286.518571	47.666667	0.024390	0.0	0.00	87.571429	9.571429	2005.63

	customer_id	gross_revenue	recency_days	purchases	unique_products_purchased	items_purchased	avg_ticket	avg_recency_days	frequency	number_returns	monetary_returns	avg_basket_size	unique_avg_basket	delta_buy_return
5627	17727	1060.25	15.0	1.0	66.0	645.0	1060.250000	6.0	1.000000	1.0	17.70	645.000000	66.0	1042.55
5637	17232	421.52	2.0	2.0	36.0	203.0	210.760000	12.0	0.153846	0.0	0.00	101.500000	18.0	421.52
5638	17468	137.00	10.0	2.0	5.0	116.0	68.500000	4.0	0.400000	0.0	0.00	58.000000	2.5	137.00
5649	13596	697.04	5.0	2.0	166.0	406.0	348.520000	7.0	0.250000	0.0	0.00	203.000000	83.0	697.04
5655	14893	1237.85	9.0	2.0	73.0	799.0	618.925000	2.0	0.666667	0.0	0.00	399.500000	36.5	1237.85
5659	12479	473.20	11.0	1.0	30.0	382.0	473.200000	4.0	1.000000	2.0	49.90	382.000000	30.0	423.30
5680	14126	706.13	7.0	3.0	15.0	508.0	235.376667	3.0	0.750000	1.0	62.50	169.333333	5.0	643.63
5686	13521	1092.39	1.0	3.0	435.0	733.0	364.130000	4.5	0.300000	0.0	0.00	244.333333	145.0	1092.39
5696	15060	301.84	8.0	4.0	120.0	262.0	75.460000	1.0	2.000000	0.0	0.00	65.500000	30.0	301.84
5715	12558	269.96	7.0	1.0	11.0	196.0	269.960000	6.0	1.000000	1.0	269.96	196.000000	11.0	0.00

Overview

Variables

Interactions

Correlations

Missing values

Sample